<?php
namespace Crm\Constant;

class TemplateConstant 
{
    public static $table_metadata = array(
        array(
            'class_name' => 'catalog',
            'table_name' => 'hy_catalog',
            'table_id'   => 'catalog_id'
        ), 
        array(
            'class_name' => 'category',
            'table_name' => 'hy_category',
            'table_id'   => 'category_id'
        ),
        array(
            'class_name' => 'order',
            'table_name' => 'hy_order',
            'table_id'   => 'order_id'
        ),
        array(
            'class_name' => 'orderitem',
            'table_name' => 'hy_orderitem',
            'table_id'   => 'oi_id'
        ),
        array(
            'class_name' => 'organization',
            'table_name' => 'hy_organization',
            'table_id'   => 'org_id'
        ),
        array(
            'class_name' => 'product',
            'table_name' => 'hy_product',
            'table_id'   => 'product_id'
        ),
        array(
            'class_name' => 'productCategory',
            'table_name' => 'hy_product_category',
            'table_id'   => 'id'
        ),
        array(
            'class_name' => 'type',
            'table_name' => 'hy_type',
            'table_id'   => 'type_id'
        ),
        array(
            'class_name' => 'user',
            'table_name' => 'hy_user',
            'table_id'   => 'user_id'
        ),
        array(
            'class_name' => 'userBalanceLog',
            'table_name' => 'hy_user_balance_log',
            'table_id'   => 'ubl_id'
        ),
        array(
            'class_name' => 'crmUser',
            'table_name' => 'hycrm_user',
            'table_id'   => 'user_id'
        ),
        array(
            'class_name' => 'monitorReport',
            'table_name' => 'hy_monitor_report',
            'table_id'   => 'monitor_report_id'
        ),
    );
    
    public static $table_column_metadata = array(
        'order'=>array(
            'tablename' => 'order',
            'columns' => array(
                'order_id' => "订单编号",
                'user_id' => "订单编号",
                'org_id' => "商户编号",
                'order_total_price' => "订单总价",
                'order_create_time' => "创建时间",
                'order_update_time' => "更新时间"
             )
        ),
        'orderitem'=> array(
            'tablename' => 'orderitem',
            'columns' => array(
                'oi_id' => '订单明细编号',
                'product_id' => '商品编号',
                'order_id' =>'订单编号',
                'oi_price' =>'价格',
                'oi_amount' =>'商品数量',
                'oi_create_time' => "创建时间",
                'oi_update_time' => "更新时间"
            )
        ),
    );

}